Interview Questions

1. Valid syntax for REFRESH CUBE statement is :

Options:

a. REFRESH CUBECube_Name

b. REFRESH CUBE ‘Cube_Name’

c. REFRESH CUBE “Cube_Name”

d. REFRESH CUBE \Cube_Name\

Reveal Answer

2. How many types of actions available in the Cube?

Options:

a. One

b. Two

c. Three

d. None

Reveal Answer

3. What are the options to deploy SSAS cube in production?

Options:

a. Using BIDS

b. Using SSMS

c. Using XMLA

d. All the above

Reveal Answer

4. _________ statement is used to write back data to any cell in a cube that aggregates to its parent using the SUM aggregation.

Options:

a. UPDATE CUBE

b. DELETE CUBE

c. ALTER CUBE

d. None of the mentioned

Reveal Answer

5. Point out the wrong statement:

Options:

a. A weight expression should be expressed as a decimal value between zero (0) and 1

b. Each UPDATE CUBE allocation should be considered to be atomic for transactional purposes

c. When updated cells overlap, the Update Isolation Level connection string property can be used to enhance performance for UPDATE CUBE

d. None of the mentioned

Reveal Answer

6. Point out the correct statement:

Options:

a. Only dropping the default member is supported in MDX Scripting

b. In the SELECT statement, the FROM clause determines the cube context

c. Very few cubes can control how errors within a Multidimensional Expressions (MDX) script are handled

d. None of the mentioned

Reveal Answer

7. Which type of relationship is used for Dimension is indirectly related to measuring group by one more dimension?

Options:

a. Referenced Relationship

b. Fact Relationship

c. Regular Relationship

d. None of these

Reveal Answer

8. What are the different types of Aggregate Functions?

Options:

a. Additive

b. Non-additive

c. Semi-Additive

d. None of these

Reveal Answer

Interview Questions and Answer

1. Valid syntax for REFRESH CUBE statement is :

2. How many types of actions available in the Cube?

3. What are the options to deploy SSAS cube in production?

4. _________ statement is used to write back data to any cell in a cube that aggregates to its parent using the SUM aggregation.

5. Point out the wrong statement:

6. Point out the correct statement:

7. Which type of relationship is used for Dimension is indirectly related to measuring group by one more dimension?

8. What are the different types of Aggregate Functions?

Packages

Trending Certification Courses:

Microsoft Mock Exams:

Other links

About

Resources